﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 管理员表实体类：fanli_adminUsers 。
	/// </summary>
	[Serializable]
	public class fanli_adminUsers
	{
		public fanli_adminUsers()
		{}

		#region Model
		private int _id; //id
		private string _username; //用户名
		private string _password; //密码
		private string _realname; //真实姓名
		private string _level; //角色
		private string _qq; //qq
		private string _email; //邮箱
		private string _telephone; //电话
		private DateTime? _lastloginTime; //最后一次登陆时间
		private string _lastloginip; //最后一次登陆ip
		private int _loginnum; //登陆次数
		private int _status; //状态
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 用户名
		/// </summary>
		public string username
		{
			set{ _username=value;}
			get{return _username;}
		}
        /// <summary>
		/// 密码
		/// </summary>
		public string password
		{
			set{ _password=value;}
			get{return _password;}
		}
        /// <summary>
		/// 真实姓名
		/// </summary>
		public string realname
		{
			set{ _realname=value;}
			get{return _realname;}
		}
        /// <summary>
		/// 角色
		/// </summary>
		public string level
		{
			set{ _level=value;}
			get{return _level;}
		}
        /// <summary>
		/// qq
		/// </summary>
		public string qq
		{
			set{ _qq=value;}
			get{return _qq;}
		}
        /// <summary>
		/// 邮箱
		/// </summary>
		public string email
		{
			set{ _email=value;}
			get{return _email;}
		}
        /// <summary>
		/// 电话
		/// </summary>
		public string telephone
		{
			set{ _telephone=value;}
			get{return _telephone;}
		}
        /// <summary>
		/// 最后一次登陆时间
		/// </summary>
		public DateTime? lastloginTime
		{
			set{ _lastloginTime=value;}
			get{return _lastloginTime;}
		}
        /// <summary>
		/// 最后一次登陆ip
		/// </summary>
		public string lastloginip
		{
			set{ _lastloginip=value;}
			get{return _lastloginip;}
		}
        /// <summary>
		/// 登陆次数
		/// </summary>
		public int loginnum
		{
			set{ _loginnum=value;}
			get{return _loginnum;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
管理员表,adminUsers
id,用户名,密码,真实姓名,角色,qq,邮箱,电话,最后一次登陆时间,最后一次登陆ip,登陆次数,状态,扩展1,扩展2
id,username,password,realname,level,qq,email,telephone,lastloginTime,lastloginip,loginnum,status,ext1,ext2
i,c40,c64,c100,c30,c20,c120,c20,d,c20,i,i,c100,c100


--------------------------
-- 创建表[管理员表]开始: 
-- alter table  [fanli_adminUsers] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_adminUsers') drop table fanli_adminUsers
  CREATE TABLE [fanli_adminUsers] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [username] [varchar] (40),
	 [password] [varchar] (64),
	 [realname] [varchar] (100),
	 [level] [varchar] (30),
	 [qq] [varchar] (20),
	 [email] [varchar] (120),
	 [telephone] [varchar] (20),
	 [lastloginTime] [datetime],
	 [lastloginip] [varchar] (20),
	 [loginnum] int,
	 [status] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'管理员表 ',N'user',N'dbo',N'table',N'fanli_adminUsers', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'用户名',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'username'
 exec sp_addextendedproperty N'MS_Description',N'密码',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'password'
 exec sp_addextendedproperty N'MS_Description',N'真实姓名',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'realname'
 exec sp_addextendedproperty N'MS_Description',N'角色',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'level'
 exec sp_addextendedproperty N'MS_Description',N'qq',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'qq'
 exec sp_addextendedproperty N'MS_Description',N'邮箱',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'email'
 exec sp_addextendedproperty N'MS_Description',N'电话',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'telephone'
 exec sp_addextendedproperty N'MS_Description',N'最后一次登陆时间',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'lastloginTime'
 exec sp_addextendedproperty N'MS_Description',N'最后一次登陆ip',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'lastloginip'
 exec sp_addextendedproperty N'MS_Description',N'登陆次数',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'loginnum'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_adminUsers',N'column',N'ext2'

-- 创建表[管理员表]结束。 
--------------------------

		*/
		#endregion document
	}
}

